﻿

CREATE PROCEDURE [dbo].[proc_Company_Range_Getlist_All]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	Select
	Id,
	ParentId,
	CompanyId,
	(Select CompanyName From Company Where Id=Company_Range.CompanyId) As CompanyName,
	(SELECT dwbh From Company Where Id=Company_Range.CompanyId) As Dwbh,
	UserName,
	Sort From Company_Range
	RETURN


